Skip to main content
Qlik Resources

Setting general connection parameters

This section describes how to configure general connection properties. For an explanation of how to configure advanced connection properties, see Setting advanced connection properties.

To add a Snowflake on Azure target endpoint to Qlik Replicate:

  1. In the Qlik Replicate Console, click Manage Endpoint Connections to open the Manage Endpoints Connections dialog box.
  2. In the Manage Endpoint Connections dialog box, click New Endpoint Connection.
  3. In the Name field, type a name for your Snowflake on Azure endpoint.
  4. Optionally, in the Description field, enter a description for your Snowflake on Azure target endpoint.

  5. Select Target as the role.

  6. Select Snowflake on Azure as the Type.

  7. Configure the remaining settings in the General tab as described below.

    • Snowflake on Azure Target:
      • Snowflake Account/Host: Your URL for accessing Snowflake on Microsoft Azure.
      • User name: Your Snowflake user name.
      • Password: The password for the user entered in the User name field.
      • Warehouse: The name of your Snowflake warehouse.
      • Database name: The name of your Snowflake database.
    • Staging:
      • Storage Type: Choose one of the following:
        • Azure Blob storage: If you select this option, you also need to provide the access and storage information specified below.
        • Snowflake: When this option is selected, Snowflake's internal storage will be used.

    • Storage account: The name of an account with write permissions to the container.

      Information note

      To connect to an Azure resource on Government Cloud or China Cloud, you need to specify the full resource name of the storage account. For example, assuming the storage account is MyBlobStorage, then the resource name for China cloud would be MyBlobStorage.dfs.core.chinacloudapi.cn

       

      For information on setting internal parameters, see Setting advanced connection properties

    • Access key: The account access key.
      • SAS token: Your SAS (Shared Access Signature) for accessing the container.
      • Container name: The container name.
      • Folder: The container folder to where the files will be copied.
Information note

To determine if you are connected to the database you want to use or if the connection information you entered is correct, click Test Connection.

If the connection is successful a message in green is displayed. If the connection fails, an error message is displayed at the bottom of the dialog box.

To view the log entry if the connection fails, click View Log. The server log is displayed with the information for the connection failure. Note that this button is not available unless the test connection fails.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here